package mindFile;

public class Hello {
	
	//case when hfydmj=0 then '0.00' when hfydmj>0 then trim(to_char(hfydmj, '99999999999.99')) else '0.00' end , 
	
	public static void main(String[] args) {
		  String[] t ={"ydmj", "gymj", "jtmj", "nydmj", "hfydmj"}; //旧厂/旧村/旧城
		  String[] t1 ={"mj","qqmj"};//国有用地
		  String[] t2 ={"mj"};//留用地
		  
		  for(String g : t1){
			  System.out.println("sbf.append(\" case when "+g+"=0 then '0.00' when "+g+">0 then trim(to_char("+g+", '99999999999.99')) else '0.00' end as "+g+",\");");
		  }
	}
}
